using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace Bet_Yatziv
{
    class AdoHelper
    {
        //get the connection string from the app.config file
        static string connectionString = Properties.Settings.Default.CompanyConnectionString.ToString();

        //declare the db connection
        static OleDbConnection con = new OleDbConnection(connectionString);
        

        /// <summary>
        /// To Execute queries which returns result set (table / relation)
        /// </summary>
        /// <param name="query">the query string</param>
        /// <returns></returns>
        public static DataTable ExecuteDataTable(string query)
        {

            try
            {
                con.Open();
                OleDbCommand command = new OleDbCommand(query, con);
                System.Data.OleDb.OleDbDataAdapter tableAdapter = new System.Data.OleDb.OleDbDataAdapter(command);
                DataTable dt = new DataTable();
                tableAdapter.Fill(dt);
                return dt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }

        /// <summary>
        /// To Execute update / insert / delete queries
        /// </summary>
        /// <param name="query">the query string</param>
        /// 
        public static void initialDataBase()
        {
            try
            {
                con.Open();
                System.Data.OleDb.OleDbCommand command;
                //************orders*************//
                command = new System.Data.OleDb.OleDbCommand("DROP TABLE tbl_orders", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("CREATE TABLE tbl_orders (orderID int,  customerID int,  roomNum int,  rentDate Date,  numOfBeds int)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (1,8,107,\"16/07/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (2,9,112,\"12/09/2011\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (3,14,129,\"08/06/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (4,7,120,\"21/10/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (5,3,115,\"11/04/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (6,11,124,\"03/10/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (7,2,113,\"23/06/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (8,4,129,\"19/01/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (9,14,106,\"05/01/2015\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (11,12,104,\"21/03/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (12,12,117,\"04/10/2011\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (13,2,105,\"30/01/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (14,3,123,\"27/05/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (15,3,114,\"26/10/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (16,10,127,\"22/04/2013\",1)", con); command.ExecuteNonQuery();
                /*command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (17,3,108,\"24/04/2015\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (18,12,127,\"13/04/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (19,14,126,\"19/02/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (20,15,112,\"24/12/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (21,11,102,\"03/05/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (22,10,118,\"08/04/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (23,9,117,\"22/08/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (24,4,113,\"02/11/2011\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (25,4,110,\"14/09/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (26,8,105,\"09/05/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (27,1,117,\"09/05/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (28,7,102,\"23/06/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (29,10,116,\"15/09/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (30,11,115,\"03/04/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (31,6,103,\"03/04/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (32,10,126,\"19/01/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (33,15,120,\"05/02/2015\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (34,3,102,\"30/11/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (35,5,125,\"19/03/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (36,6,107,\"09/08/2011\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (37,12,100,\"02/06/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (38,5,117,\"27/04/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (39,1,117,\"30/06/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (40,9,119,\"19/10/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (41,15,130,\"27/06/2011\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (42,7,110,\"11/03/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (43,6,105,\"28/08/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (44,3,115,\"13/05/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (45,2,105,\"27/08/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (46,3,115,\"05/04/2015\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (47,9,102,\"01/05/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (48,2,104,\"23/09/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (49,1,124,\"20/02/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (50,1,108,\"08/12/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (51,8,128,\"10/09/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (52,14,102,\"04/12/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (53,3,128,\"04/10/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (54,1,107,\"27/06/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (55,3,128,\"07/12/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (56,4,122,\"18/03/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (57,8,121,\"20/10/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (58,1,112,\"10/02/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (59,10,102,\"22/03/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (60,6,102,\"24/12/2011\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (61,10,115,\"28/12/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (62,14,111,\"25/05/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (63,3,115,\"20/03/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (64,1,120,\"14/01/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (65,8,111,\"04/05/2015\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (66,6,119,\"06/09/2011\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (67,2,116,\"17/03/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (68,1,118,\"20/10/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (69,5,121,\"19/03/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (70,8,123,\"03/10/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (71,12,107,\"08/06/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (72,13,121,\"13/08/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (73,9,110,\"14/05/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (74,6,126,\"20/10/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (75,9,106,\"17/06/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (76,11,127,\"03/02/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (77,8,130,\"31/03/2014\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (78,15,106,\"21/01/2015\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (79,4,102,\"16/05/2015\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (80,8,107,\"13/08/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (81,6,121,\"02/08/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (82,1,112,\"25/02/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (83,13,110,\"15/09/2011\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (84,5,115,\"15/07/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (85,9,102,\"26/04/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (86,13,102,\"31/08/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (87,13,109,\"08/07/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (88,15,104,\"26/03/2013\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (89,12,124,\"20/03/2012\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (90,12,129,\"07/05/2015\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (91,9,118,\"20/03/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (92,15,122,\"17/12/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (93,1,114,\"12/09/2011\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (94,13,124,\"20/07/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (95,10,111,\"18/08/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (96,4,100,\"05/12/2013\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (97,5,126,\"02/03/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (98,7,103,\"25/04/2012\",2)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (99,10,108,\"09/05/2014\",1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_orders (orderID,customerID,roomNum,rentDate,numOfBeds) VALUES (100,9,128,\"13/06/2011\",1)", con); command.ExecuteNonQuery();
                //************rooms*************/
                command = new System.Data.OleDb.OleDbCommand("DROP TABLE tbl_rooms", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("CREATE TABLE tbl_rooms (roomID int NOT NULL, type varchar(255), price int, maxBeds int, available bit);", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (281,\"Suite\",1151,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (277,\"Suite\",1760,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (209,\"Suite\",1130,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (263,\"Regular\",1388,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (286,\"Suite\",841,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (184,\"Regular\",1136,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (126,\"Regular\",1157,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (289,\"VIP\",1620,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (107,\"VIP\",971,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (171,\"Suite\",1948,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (290,\"Deluxe\",1254,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (203,\"Suite\",1253,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (238,\"Regular\",1654,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (199,\"Suite\",1758,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (298,\"VIP\",903,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (186,\"Regular\",1070,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (216,\"Regular\",690,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (214,\"Deluxe\",821,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (138,\"Regular\",1821,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (197,\"Suite\",1944,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (153,\"Regular\",1877,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (244,\"Deluxe\",543,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (149,\"Suite\",984,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (206,\"VIP\",633,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (114,\"Regular\",1535,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (121,\"VIP\",1133,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (279,\"Suite\",1623,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (118,\"Suite\",1958,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (232,\"Deluxe\",1300,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (215,\"Regular\",903,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (298,\"Suite\",1030,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (152,\"Regular\",1229,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (168,\"Suite\",512,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (131,\"Deluxe\",1251,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (113,\"Regular\",1807,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (124,\"VIP\",660,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (114,\"Deluxe\",1090,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (231,\"VIP\",1883,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (213,\"Suite\",1150,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (292,\"Regular\",1304,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (272,\"Regular\",1630,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (262,\"Regular\",1073,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (261,\"Suite\",809,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (168,\"Suite\",1076,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (200,\"Regular\",1120,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (281,\"Regular\",501,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (146,\"Deluxe\",585,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (278,\"Regular\",1631,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (282,\"Deluxe\",1388,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (271,\"Regular\",504,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (235,\"VIP\",1344,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (140,\"Regular\",964,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (260,\"Suite\",847,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (168,\"Suite\",1745,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (234,\"Regular\",1398,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (223,\"Deluxe\",1504,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (160,\"Deluxe\",862,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (185,\"Regular\",932,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (184,\"Deluxe\",1405,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (103,\"VIP\",1097,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (243,\"Suite\",1936,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (295,\"Deluxe\",1365,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (182,\"Suite\",1915,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (117,\"VIP\",1168,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (268,\"VIP\",1267,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (289,\"Suite\",1714,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (208,\"Regular\",1817,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (293,\"Deluxe\",1135,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (129,\"Deluxe\",913,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (110,\"VIP\",1915,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (235,\"Suite\",1890,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (220,\"Regular\",1725,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (253,\"Regular\",703,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (252,\"Regular\",555,2,1)", con);command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (150,\"Regular\",1375,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (244,\"Deluxe\",1290,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (205,\"Regular\",565,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (165,\"Deluxe\",1506,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (135,\"Deluxe\",1712,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (219,\"Deluxe\",1001,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (275,\"Deluxe\",1718,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (281,\"VIP\",1731,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (120,\"Suite\",538,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (115,\"Deluxe\",1319,1,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (144,\"Suite\",1076,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (205,\"Regular\",1682,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (146,\"Regular\",1881,2,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (209,\"Deluxe\",1099,2,0)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (300,\"VIP\",1026,1,1)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_rooms (roomID,type,price,maxBeds,available) VALUES (162,\"VIP\",539,1,0)", con); command.ExecuteNonQuery();
                //*************employees*************//
                command = new System.Data.OleDb.OleDbCommand("DROP TABLE tbl_employees", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("CREATE TABLE tbl_employees (employeeID int,  firstName varchar(255),  lastName varchar(255),  address varchar(255),  cellPhone varchar(100),  wage int,  birthDate DATE);", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (10,\"April\",\"Brown\",\"P.O. Box 114, 8319 Senectus Avenue\",\"056-392-5673\",5870,\"05/01/96\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (11,\"Charity\",\"William\",\"438-7902 Neque St.\",\"054-730-1963\",6939,\"05/07/87\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (12,\"Ivor\",\"Cline\",\"Ap #294-3079 Quam. Street\",\"059-531-6069\",5344,\"10/26/85\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (13,\"Tucker\",\"Cervantes\",\"687-7390 Phasellus St.\",\"058-045-8067\",6798,\"03/30/95\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (14,\"Isaiah\",\"Drake\",\"664-5708 Sit Av.\",\"059-681-6320\",4774,\"03/16/90\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (15,\"Garrett\",\"Hendrix\",\"P.O. Box 852, 6048 Interdum. Street\",\"054-622-5732\",4341,\"02/18/86\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (16,\"Ava\",\"Benjamin\",\"738-7991 Sed Ave\",\"054-003-3904\",5626,\"05/27/62\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (17,\"Barry\",\"Kent\",\"282-1294 Neque Street\",\"055-218-8295\",6603,\"11/29/90\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (18,\"Amir\",\"Moon\",\"Ap #817-256 Dictum Rd.\",\"059-641-7584\",4699,\"10/27/75\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (19,\"Leonard\",\"Peters\",\"5343 Quisque St.\",\"056-257-4767\",5205,\"07/10/72\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (20,\"Luke\",\"Olsen\",\"Ap #521-7207 Augue Rd.\",\"050-274-4088\",6561,\"02/21/95\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (21,\"Ivan\",\"Cantu\",\"Ap #900-4590 Aliquet St.\",\"057-734-9592\",3608,\"11/20/60\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (22,\"Lewis\",\"King\",\"4149 Est. St.\",\"052-148-2238\",5514,\"11/04/78\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (23,\"Leila\",\"Butler\",\"8087 Semper St.\",\"051-125-8522\",3178,\"05/29/82\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (24,\"Clarke\",\"Morton\",\"P.O. Box 442, 1148 Diam. Av.\",\"057-827-2934\",5021,\"06/24/69\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (25,\"Judah\",\"Arnold\",\"Ap #644-5108 Ante Ave\",\"055-729-0552\",6734,\"06/01/90\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (26,\"Yoshi\",\"Rhodes\",\"357-5327 Eu Street\",\"058-172-1551\",3617,\"08/28/71\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (27,\"Aurelia\",\"Pennington\",\"Ap #447-6521 Vitae Avenue\",\"053-313-7600\",5146,\"02/14/95\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (28,\"Megan\",\"Anderson\",\"Ap #432-9212 Auctor Street\",\"057-134-0968\",4418,\"07/31/62\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (29,\"Keefe\",\"Day\",\"500-3919 Vulputate St.\",\"050-023-7961\",6491,\"09/23/61\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (30,\"Yuli\",\"Parrish\",\"P.O. Box 773, 9166 Tortor, Av.\",\"054-347-7388\",4869,\"08/13/84\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (31,\"Mohammad\",\"Farley\",\"P.O. Box 308, 2012 Amet St.\",\"057-412-8351\",4524,\"05/05/71\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (32,\"Hamish\",\"Harvey\",\"P.O. Box 656, 7094 Donec Rd.\",\"056-776-4877\",6999,\"12/12/60\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (33,\"Celeste\",\"Pacheco\",\"Ap #417-9587 Malesuada Rd.\",\"051-019-0694\",3042,\"02/06/83\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (34,\"Raya\",\"Blevins\",\"P.O. Box 343, 2288 Faucibus Rd.\",\"050-621-3549\",6214,\"06/14/88\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (35,\"Cadman\",\"Melendez\",\"397-3371 Aptent Avenue\",\"056-216-6341\",3288,\"03/09/94\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (36,\"Angelica\",\"Gallegos\",\"316-3208 Eget Rd.\",\"053-354-1919\",4638,\"04/24/69\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (37,\"Talon\",\"Dillard\",\"P.O. Box 890, 7979 Tempor St.\",\"059-646-0754\",4419,\"11/04/92\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (38,\"Melyssa\",\"Sims\",\"Ap #468-326 Odio. Rd.\",\"053-483-9092\",5745,\"01/17/89\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (39,\"Elvis\",\"Mcmahon\",\"3710 Dis Rd.\",\"053-969-8920\",6738,\"07/18/95\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (40,\"Sybill\",\"Craft\",\"7157 Aliquet, Rd.\",\"051-161-4137\",6277,\"10/08/93\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (41,\"MacKenzie\",\"Page\",\"5958 Cras Road\",\"059-949-0512\",5045,\"05/06/76\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (42,\"Alice\",\"Rosario\",\"Ap #667-3746 Tincidunt Rd.\",\"059-187-0702\",3014,\"01/19/74\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (43,\"Fay\",\"Branch\",\"6619 Justo. St.\",\"055-960-8451\",3906,\"12/30/73\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (44,\"Elliott\",\"Wilcox\",\"111-1321 Eget Street\",\"051-878-9618\",4453,\"09/10/64\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (45,\"Leigh\",\"Lester\",\"P.O. Box 225, 4372 Etiam Rd.\",\"052-704-2229\",5593,\"04/25/79\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (46,\"Kylynn\",\"Baird\",\"P.O. Box 643, 8951 Tellus Rd.\",\"052-486-7626\",6159,\"08/26/81\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (47,\"Galena\",\"Singleton\",\"4941 Quam Avenue\",\"051-659-8902\",6138,\"02/01/93\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (48,\"Lani\",\"Allen\",\"Ap #879-4317 Leo, Rd.\",\"057-350-5639\",5042,\"02/07/84\")", con); command.ExecuteNonQuery();
                /*command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (49,\"Selma\",\"Key\",\"P.O. Box 233, 1333 Arcu St.\",\"052-375-7927\",5638,\"01/14/81\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (50,\"Demetria\",\"Leach\",\"988-6114 Nisi St.\",\"055-660-8615\",5851,\"10/25/75\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (51,\"Barry\",\"Walsh\",\"8936 Amet Rd.\",\"057-029-7899\",5980,\"02/26/80\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (52,\"Xandra\",\"Cabrera\",\"9226 A, Ave\",\"050-928-2317\",3044,\"11/21/86\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (53,\"Emmanuel\",\"Park\",\"Ap #637-1552 Ullamcorper Rd.\",\"050-518-0835\",4065,\"09/23/64\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (54,\"Shannon\",\"Leach\",\"733-5384 Sed, Avenue\",\"057-840-7407\",4389,\"08/03/90\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (55,\"Jenna\",\"Hughes\",\"P.O. Box 807, 4272 Purus Avenue\",\"051-683-6675\",6249,\"09/23/85\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (56,\"Bert\",\"Greer\",\"Ap #783-6470 Nibh. Av.\",\"050-134-8240\",3176,\"01/03/84\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (57,\"Quintessa\",\"Duffy\",\"Ap #461-7917 Gravida Av.\",\"058-894-9688\",6812,\"05/27/83\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (58,\"Raymond\",\"Suarez\",\"Ap #452-8817 A, Rd.\",\"054-469-1211\",6208,\"11/20/93\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (59,\"Chandler\",\"Joyce\",\"4688 Pellentesque, Rd.\",\"057-032-6474\",6810,\"11/20/79\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (60,\"Avye\",\"White\",\"Ap #829-2519 Tortor. Ave\",\"053-645-1026\",4074,\"01/27/68\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (61,\"Quentin\",\"Jenkins\",\"1516 Nunc. Avenue\",\"051-033-7091\",3158,\"01/16/67\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (62,\"Nevada\",\"Mercado\",\"P.O. Box 994, 2920 Pulvinar St.\",\"057-758-3099\",3358,\"08/24/66\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (63,\"Cora\",\"Horton\",\"Ap #633-1885 Porttitor Road\",\"054-380-1782\",4959,\"02/27/64\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (64,\"Jelani\",\"Mendez\",\"P.O. Box 999, 1955 Nulla Av.\",\"059-647-3834\",4708,\"05/15/75\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (65,\"Simon\",\"Jimenez\",\"P.O. Box 883, 4752 Sagittis St.\",\"051-945-7239\",6497,\"02/19/96\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (66,\"Yoshio\",\"Stafford\",\"Ap #365-213 Lorem, Street\",\"059-414-4273\",3020,\"06/23/76\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (67,\"Zia\",\"Mcfadden\",\"6964 Pellentesque Ave\",\"053-840-2130\",4534,\"02/07/87\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (68,\"Alisa\",\"Ewing\",\"Ap #810-2358 Mus. Av.\",\"050-572-8471\",4959,\"10/20/71\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (69,\"Noah\",\"Hickman\",\"P.O. Box 449, 3924 Nam Street\",\"059-448-3839\",3669,\"04/30/72\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (70,\"Nicole\",\"Gould\",\"462-8784 Vulputate Av.\",\"053-188-6925\",6821,\"02/07/75\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (71,\"Ezra\",\"Le\",\"Ap #125-314 Integer Rd.\",\"052-916-3475\",5371,\"05/04/96\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (72,\"Colby\",\"Padilla\",\"846-9551 Nonummy Av.\",\"055-306-5304\",6535,\"03/07/66\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (73,\"Zane\",\"Knight\",\"506-5833 Ad St.\",\"051-411-5748\",5487,\"10/21/71\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (74,\"Abel\",\"Salazar\",\"277-9591 Volutpat Av.\",\"053-007-6691\",3022,\"12/07/71\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (75,\"Damon\",\"Kramer\",\"221-5610 Id Street\",\"052-873-9824\",6170,\"10/05/60\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (76,\"Fitzgerald\",\"Phillips\",\"Ap #869-8440 Vulputate, St.\",\"056-818-7987\",4576,\"08/03/63\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (77,\"Carter\",\"Barrera\",\"5901 Eros. Rd.\",\"058-870-6817\",6284,\"03/01/81\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (78,\"Reagan\",\"Baldwin\",\"905-6180 Nunc Rd.\",\"051-308-4117\",6946,\"03/15/91\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (79,\"Ashely\",\"Berger\",\"P.O. Box 821, 7772 Malesuada Av.\",\"055-978-6114\",5600,\"01/30/86\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (80,\"Kibo\",\"Osborn\",\"667-7998 Et, St.\",\"059-273-8381\",4522,\"12/25/95\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (81,\"Sloane\",\"Long\",\"522 Magnis Ave\",\"050-960-7803\",5480,\"11/19/71\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (82,\"Caleb\",\"Hopper\",\"839-114 Duis Av.\",\"058-452-7126\",6629,\"11/28/79\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (83,\"Sade\",\"Haynes\",\"3599 Neque Road\",\"056-028-0782\",4567,\"05/12/69\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (84,\"Troy\",\"Evans\",\"Ap #305-9606 Sit St.\",\"056-375-0677\",4726,\"02/15/94\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (85,\"Carlos\",\"Davidson\",\"183-3338 Ac St.\",\"057-595-9295\",5417,\"08/29/79\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (86,\"Lara\",\"Stewart\",\"452-3515 A, Av.\",\"057-960-4725\",3148,\"10/22/64\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (87,\"Ferris\",\"Brock\",\"Ap #534-6669 Non, Road\",\"053-894-0047\",4711,\"11/17/94\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (88,\"Levi\",\"Gamble\",\"Ap #999-4395 In Av.\",\"052-420-9047\",6118,\"10/24/69\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (89,\"Callie\",\"Sanford\",\"6385 In Street\",\"058-013-9075\",6103,\"02/08/71\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (90,\"Lavinia\",\"Morton\",\"Ap #226-7898 Nec St.\",\"051-226-2497\",3211,\"08/18/64\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (91,\"Lynn\",\"Knox\",\"728-4728 Turpis. Av.\",\"058-029-9296\",3208,\"01/04/95\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (92,\"Sopoline\",\"Gamble\",\"4898 Aliquet, Ave\",\"051-990-2634\",4197,\"10/24/62\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (93,\"Tamara\",\"Reeves\",\"Ap #693-2391 Tincidunt Av.\",\"050-606-3444\",5669,\"09/30/64\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (94,\"Noel\",\"Schneider\",\"Ap #528-5026 Non Ave\",\"054-579-4109\",3687,\"11/21/85\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (96,\"Maryam\",\"Johns\",\"8620 Vivamus Ave\",\"053-590-9420\",6006,\"06/24/74\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (97,\"Naida\",\"Lawson\",\"P.O. Box 298, 1073 Congue Rd.\",\"055-321-0242\",4074,\"07/28/71\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (98,\"Rana\",\"Mcfadden\",\"858 Urna. Road\",\"054-560-7439\",5335,\"01/28/87\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (99,\"Sage\",\"Crosby\",\"Ap #889-5797 Eget Av.\",\"056-330-4029\",4089,\"12/09/65\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (100,\"Mark\",\"Pierce\",\"Ap #543-7126 Scelerisque, Avenue\",\"054-172-5709\",6790,\"10/12/89\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (101,\"Ezekiel\",\"Head\",\"3262 Donec St.\",\"055-227-7691\",3346,\"04/01/94\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (102,\"Selma\",\"Christian\",\"7976 Diam St.\",\"052-554-8609\",3422,\"12/26/92\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (103,\"Beck\",\"Clay\",\"P.O. Box 238, 1525 Euismod Avenue\",\"053-500-5946\",4221,\"08/23/62\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (104,\"Arden\",\"Porter\",\"143-6638 Aliquam Avenue\",\"054-261-5931\",5070,\"09/26/79\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (105,\"Celeste\",\"Mccoy\",\"8401 Donec Street\",\"058-313-5776\",4088,\"05/03/66\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (106,\"Venus\",\"Webb\",\"P.O. Box 226, 3187 Aenean Rd.\",\"054-078-4317\",4570,\"03/28/72\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (107,\"Isaiah\",\"Cantu\",\"Ap #567-7855 Penatibus Ave\",\"057-689-2217\",3094,\"02/29/96\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (108,\"Madeson\",\"Bernard\",\"P.O. Box 312, 9841 Facilisis Road\",\"053-706-5356\",4183,\"07/04/60\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_employees (employeeID,firstName,lastName,address,cellPhone,wage,birthDate) VALUES (109,\"Rose\",\"Whitehead\",\"Ap #104-2642 Facilisis. Ave\",\"054-953-5136\",3053,\"12/30/67\")", con); command.ExecuteNonQuery();*/
                //******************customers***************//
                command = new System.Data.OleDb.OleDbCommand("DROP TABLE tbl_costumers", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("CREATE TABLE tbl_costumers(costumerID INT PRIMARY KEY,	firstName VARCHAR(50),	lastName VARCHAR(50),	address VARCHAR(50),	homePhone VARCHAR(50),	cellPhone VARCHAR(50),	payingMethod VARCHAR(50));", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (100,\"Reed\",\"Wilson\",\"202-5243 Ultrices, Street\",\"08-763-9160\",\"059-951-0321\",\"340926881418\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (101,\"Michelle\",\"Giles\",\"5099 Ac Av.\",\"01-548-1772\",\"051-504-0502\",\"9084326573875225\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (102,\"Gavin\",\"Barton\",\"5643 Donec St.\",\"02-402-2132\",\"059-502-5260\",\"84325870362092\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (103,\"Noelani\",\"Richmond\",\"2036 Erat Rd.\",\"06-056-4303\",\"058-273-5963\",\"709535785172460\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (104,\"Elvis\",\"Oneil\",\"P.O. Box 223, 7433 Orci. Road\",\"02-031-4538\",\"053-830-2199\",\"4373482570031105\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (105,\"Oliver\",\"Floyd\",\"P.O. Box 882, 9557 Duis Avenue\",\"05-978-3622\",\"058-683-8185\",\"8054189419266936\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (106,\"Erasmus\",\"Sosa\",\"4337 A Rd.\",\"06-662-0837\",\"054-386-8308\",\"48914387257070\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (107,\"Moses\",\"Dillard\",\"8319 Turpis Rd.\",\"07-764-7377\",\"052-334-9061\",\"6759 2581 7726 0803\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (108,\"Mohammad\",\"Dale\",\"190 Egestas Rd.\",\"08-811-6189\",\"059-541-5323\",\"7248 0431 4101 5559\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (109,\"Noelle\",\"Cole\",\"Ap #559-3269 Quis St.\",\"04-866-9227\",\"055-249-1797\",\"320453 1922298270\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (110,\"Yuri\",\"Strickland\",\"P.O. Box 340, 2966 Phasellus Ave\",\"05-294-6317\",\"052-349-0259\",\"39501539550659\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (111,\"Forrest\",\"Roach\",\"5197 Ligula. St.\",\"08-290-8300\",\"058-756-4027\",\"09830063606090\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (112,\"Nichole\",\"Ramirez\",\"2106 Amet Ave\",\"03-225-4616\",\"056-390-3648\",\"60984334331024\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (113,\"Blake\",\"Pate\",\"P.O. Box 318, 5864 Sed St.\",\"05-513-6577\",\"058-187-0484\",\"78448567854995\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (114,\"Sopoline\",\"Larson\",\"227-5663 Sit Street\",\"04-964-8733\",\"056-692-7253\",\"3909 8458 1577 1070\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (115,\"Xenos\",\"Hoover\",\"P.O. Box 512, 1706 Aliquam St.\",\"00-247-3321\",\"057-014-5897\",\"181161284272110\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (116,\"Cairo\",\"Phillips\",\"378-5567 Pulvinar Av.\",\"02-331-0437\",\"059-145-6607\",\"6850133408782982\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (117,\"Laurel\",\"Becker\",\"4254 Porta Av.\",\"05-507-0394\",\"056-167-3412\",\"4227118430516\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (118,\"Briar\",\"Lott\",\"Ap #943-1521 Elit Avenue\",\"04-092-6850\",\"055-226-7326\",\"64575795115538\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (119,\"Shad\",\"Powers\",\"181-1100 Varius Av.\",\"02-100-5668\",\"056-856-5500\",\"102 82346 33908 901\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (120,\"Kato\",\"Donaldson\",\"9731 Pede St.\",\"05-111-0453\",\"056-205-0221\",\"964030345247861\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (121,\"Scarlett\",\"Goodman\",\"453-7077 Sed Road\",\"03-557-6954\",\"057-487-1274\",\"367978456583941\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (122,\"Aphrodite\",\"Navarro\",\"2780 Varius. Rd.\",\"01-644-4575\",\"059-780-5987\",\"615379 5122808873\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (123,\"Moana\",\"Young\",\"P.O. Box 743, 5545 Nullam Avenue\",\"06-409-8470\",\"055-415-8746\",\"04480566412029\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (124,\"Karen\",\"Oneil\",\"P.O. Box 176, 2125 In Ave\",\"03-488-4974\",\"052-700-6296\",\"79867925983924\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (125,\"Briar\",\"Stein\",\"5901 Eget, Road\",\"08-969-2183\",\"053-082-8008\",\"67315996462273\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (126,\"Madeline\",\"Lynn\",\"Ap #343-3103 At, Avenue\",\"02-615-8800\",\"054-899-5210\",\"2656369025841638\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (127,\"Bert\",\"Stevens\",\"P.O. Box 567, 5978 Nulla Av.\",\"03-136-4823\",\"056-372-0178\",\"200 17806 44921 019\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (128,\"Melanie\",\"Workman\",\"Ap #647-1002 Cubilia Rd.\",\"05-926-8210\",\"054-533-0996\",\"4011037162433286117\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (129,\"Macon\",\"Drake\",\"Ap #471-2674 Dolor, Avenue\",\"03-427-2328\",\"054-325-9943\",\"823118631122455401\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (130,\"Keane\",\"Sweet\",\"623-6177 Sem Ave\",\"01-905-9410\",\"054-473-9657\",\"738963 2591526765\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (131,\"Ezekiel\",\"Barber\",\"P.O. Box 182, 6109 Leo, Street\",\"08-869-9357\",\"050-996-0044\",\"12875389502707395\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (132,\"Carson\",\"Robles\",\"P.O. Box 637, 4310 Dui, Avenue\",\"06-418-6188\",\"053-363-8041\",\"46616480991123\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (133,\"Tobias\",\"Nash\",\"102 Habitant Road\",\"02-162-8343\",\"058-287-6539\",\"3353 8305 1173 0878\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (134,\"Barry\",\"Rosario\",\"Ap #845-2460 Quis Av.\",\"08-240-3802\",\"058-635-8436\",\"535866333038687144\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (135,\"Naomi\",\"Hardin\",\"Ap #339-3848 Eget, St.\",\"09-863-7676\",\"059-319-2900\",\"498213243215702\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (136,\"Omar\",\"Donovan\",\"P.O. Box 480, 1700 Risus Avenue\",\"05-128-1544\",\"058-285-6505\",\"561123 5517543874\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (137,\"Clark\",\"Stone\",\"Ap #717-5883 Tempor, St.\",\"09-952-9384\",\"051-257-3029\",\"70468500367806475\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (138,\"Venus\",\"Mccarty\",\"9389 Augue Av.\",\"04-439-1191\",\"059-625-4939\",\"17135757842765\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (139,\"Raven\",\"Macdonald\",\"5644 Dolor Street\",\"09-334-2600\",\"055-491-2079\",\"5012 629078 42090\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (140,\"McKenzie\",\"Fischer\",\"3164 A Rd.\",\"04-269-7908\",\"050-206-3423\",\"937 83274 45022 785\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (141,\"Vielka\",\"Park\",\"Ap #277-1643 Massa. Street\",\"07-672-4328\",\"054-383-2809\",\"6682519964549319762\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (142,\"Charles\",\"Vazquez\",\"P.O. Box 642, 1208 Primis Road\",\"02-860-8978\",\"053-275-1804\",\"563271215401206019\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (143,\"Nayda\",\"Robles\",\"Ap #986-8913 Sit Road\",\"08-991-7181\",\"054-580-9952\",\"165476 37 4578 4666 752\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (144,\"Jack\",\"Sweet\",\"322-1238 Euismod Av.\",\"06-368-5285\",\"058-417-6372\",\"3159953395903\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (145,\"Azalia\",\"Allison\",\"817-6595 Nibh. St.\",\"08-614-7061\",\"056-281-1316\",\"997697136300728\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (146,\"Rigel\",\"Mullins\",\"P.O. Box 846, 2015 Sociis Rd.\",\"05-211-9882\",\"051-814-4727\",\"2407 3922 4577 2690\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (147,\"Lacota\",\"Hyde\",\"Ap #789-299 Amet Rd.\",\"07-307-6469\",\"051-494-4690\",\"056869090608234\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (148,\"Mira\",\"Swanson\",\"P.O. Box 336, 1686 Sed St.\",\"00-490-5985\",\"053-467-5044\",\"95054298432816788\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (149,\"Natalie\",\"Moss\",\"P.O. Box 644, 9501 Elit St.\",\"04-098-0345\",\"052-040-7021\",\"62681319516030749\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (150,\"Susan\",\"Mckenzie\",\"830-6920 Lectus Av.\",\"07-218-6224\",\"055-518-4764\",\"48393982209150\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (151,\"Merrill\",\"Dudley\",\"Ap #431-5148 Convallis St.\",\"05-481-5739\",\"056-633-8569\",\"00823061737857976\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (152,\"Allen\",\"Cantu\",\"P.O. Box 508, 927 In Ave\",\"02-520-3490\",\"052-239-9031\",\"3168473611304578424\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (153,\"Idola\",\"Larson\",\"P.O. Box 169, 9423 Ante, St.\",\"09-324-3135\",\"051-335-3820\",\"25403666592290959\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (154,\"Sierra\",\"Berg\",\"P.O. Box 460, 5607 Elit. St.\",\"01-833-1163\",\"054-764-8555\",\"1016 4424 1113 2032\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (155,\"Avye\",\"Bishop\",\"433-6986 Mauris Road\",\"08-674-2786\",\"058-521-9235\",\"8155606720589219927\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (156,\"Mohammad\",\"Sampson\",\"P.O. Box 616, 6020 Pellentesque Rd.\",\"04-742-5891\",\"056-497-1691\",\"2352 5964 5438 8940\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (157,\"Allen\",\"Singleton\",\"665-2100 Eu Ave\",\"09-941-9477\",\"059-229-6770\",\"972681650842363\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (158,\"Damian\",\"Estrada\",\"P.O. Box 383, 3569 Arcu. Rd.\",\"07-188-0558\",\"058-853-1322\",\"7234039741459433\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (159,\"Ferris\",\"Grant\",\"715-7411 Tortor Av.\",\"05-121-8265\",\"051-586-1795\",\"06936906421481\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (160,\"Axel\",\"Branch\",\"P.O. Box 681, 8136 Adipiscing. St.\",\"03-102-3071\",\"058-552-2835\",\"147479 6021791486\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (161,\"Portia\",\"Aguirre\",\"P.O. Box 364, 3086 A Rd.\",\"03-145-4497\",\"058-224-8819\",\"817113 573540 4683\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (162,\"Blythe\",\"Vasquez\",\"Ap #395-2051 Ligula. Road\",\"04-051-6253\",\"055-771-6543\",\"922360708044683\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (163,\"Alexander\",\"Fischer\",\"982-2763 Bibendum Ave\",\"09-862-1017\",\"057-087-3062\",\"5325 258293 10203\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (164,\"Gage\",\"Steele\",\"P.O. Box 855, 2051 Bibendum Road\",\"04-602-4629\",\"050-920-0969\",\"2039196876838092\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (165,\"Solomon\",\"Saunders\",\"Ap #344-1757 Mauris Rd.\",\"01-480-4342\",\"054-992-7041\",\"857511182854885\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (166,\"Yoshi\",\"Crane\",\"P.O. Box 593, 1504 Venenatis St.\",\"03-368-5358\",\"050-229-8877\",\"6748 281783 13416\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (167,\"Beau\",\"Pierce\",\"733-6092 Conubia Road\",\"02-814-1411\",\"052-471-3778\",\"3001690272831\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (168,\"Kevin\",\"Oliver\",\"5979 Sed Rd.\",\"02-068-0768\",\"053-734-3338\",\"041744359484604579\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (169,\"Karina\",\"Campos\",\"6948 Ut Rd.\",\"05-274-1366\",\"054-450-5700\",\"18003083054019\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (170,\"Kimberly\",\"Horne\",\"863-9473 Adipiscing. Avenue\",\"01-943-0017\",\"052-129-4621\",\"52287508113313\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (171,\"Jakeem\",\"Yang\",\"8642 Tellus Road\",\"07-306-6072\",\"050-860-6885\",\"6750538307610731\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (172,\"Zeph\",\"Brewer\",\"Ap #328-2864 Nunc Street\",\"07-394-8309\",\"054-151-0837\",\"294000 3387831772\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (173,\"Ariana\",\"Nixon\",\"P.O. Box 591, 6544 Commodo Road\",\"08-443-6032\",\"059-168-3258\",\"037110 958934 0736\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (174,\"Yen\",\"Poole\",\"P.O. Box 725, 5738 Neque Road\",\"08-605-7620\",\"053-882-2915\",\"969464 649677 1934\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (175,\"Danielle\",\"Craig\",\"4579 Donec St.\",\"07-828-9471\",\"053-536-7114\",\"15936907457830\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (176,\"Scott\",\"Cox\",\"Ap #466-7084 Libero St.\",\"02-049-3526\",\"050-835-5755\",\"762 22059 06873 268\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (177,\"Isadora\",\"Sweet\",\"Ap #252-5414 Nunc Road\",\"09-820-2540\",\"057-940-7379\",\"6443386472247092\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (178,\"Jacob\",\"Key\",\"6901 Tincidunt St.\",\"01-517-4054\",\"052-537-2784\",\"51234804936840\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (179,\"Hiram\",\"Sanders\",\"675-4224 Erat, Road\",\"09-388-6808\",\"051-161-8614\",\"359865 4564312532\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (180,\"Arsenio\",\"Bradley\",\"Ap #434-3989 Sed, Avenue\",\"00-134-6844\",\"059-052-8441\",\"6383247179295598\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (181,\"Ali\",\"Gould\",\"3763 Quis Avenue\",\"09-654-2332\",\"051-685-2108\",\"48765589730805\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (182,\"Freya\",\"Pennington\",\"P.O. Box 725, 950 Proin Av.\",\"03-299-7931\",\"051-016-2308\",\"8227369410201874\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (183,\"Cailin\",\"Crosby\",\"5585 Natoque Rd.\",\"03-789-2913\",\"051-304-0433\",\"8995242468108947\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (184,\"Elizabeth\",\"Ratliff\",\"Ap #965-4362 Integer Rd.\",\"03-347-0940\",\"058-180-6000\",\"5574 783818 85248\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (185,\"Nell\",\"Conley\",\"1042 Parturient Av.\",\"06-838-1028\",\"057-606-8325\",\"682935 854570 1227\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (186,\"Pamela\",\"Simpson\",\"Ap #637-9963 Velit Street\",\"03-343-2764\",\"057-828-0752\",\"88729024585076\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (187,\"Oleg\",\"Michael\",\"Ap #321-9841 Sed Avenue\",\"00-516-4983\",\"057-209-5164\",\"8142 541254 50717\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (188,\"Armand\",\"Cummings\",\"5679 Metus Ave\",\"04-227-0831\",\"056-684-3303\",\"252222908155117\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (189,\"Stacy\",\"Rivas\",\"1032 Ipsum. Rd.\",\"01-185-1652\",\"059-092-3981\",\"374768 271189 1553\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (190,\"Morgan\",\"Brennan\",\"238-4426 Adipiscing Road\",\"04-575-9910\",\"050-275-1404\",\"92201593153151\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (191,\"Nerea\",\"Santos\",\"544 Aptent Ave\",\"06-559-5955\",\"052-820-6296\",\"0858839044826117\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (192,\"Conan\",\"Marquez\",\"380-8706 Rutrum, Street\",\"00-608-1012\",\"055-144-8247\",\"961820424861827338\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (193,\"Griffith\",\"Burks\",\"Ap #852-6293 Euismod Av.\",\"01-208-0567\",\"057-004-2188\",\"42226553358269\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (194,\"Lacy\",\"Horn\",\"307 Egestas, Road\",\"01-215-0178\",\"052-933-4181\",\"842181 2649323930\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (195,\"Uriel\",\"Vazquez\",\"7995 Dignissim. St.\",\"02-393-6468\",\"056-901-8706\",\"466503 4072856989\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (196,\"Malik\",\"Barry\",\"Ap #974-2305 Enim. Av.\",\"03-324-2339\",\"056-534-4462\",\"048555 2697729279\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (197,\"Imani\",\"Underwood\",\"820-2439 Quis Av.\",\"09-977-9025\",\"056-552-2910\",\"301630115319766\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (198,\"Aladdin\",\"Battle\",\"380-6738 Lectus St.\",\"04-421-7991\",\"050-561-3792\",\"9472 819171 70294\")", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_costumers (costumerID,firstName,lastName,address,homePhone,cellPhone,payingMethod) VALUES (199,\"Lucian\",\"Elliott\",\"1934 Sem. Avenue\",\"05-818-8448\",\"053-454-5723\",\"55131076713566\")", con); command.ExecuteNonQuery();
                //************warehouse**********//
                command = new System.Data.OleDb.OleDbCommand("DROP TABLE tbl_warehouse", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("CREATE TABLE tbl_warehouse (itemID int,  description varchar(255),  amount int, minAmount int);", con);command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount,minAmount) VALUES (1000,\"tooth paste\",232,150)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount,minAmount) VALUES (1001,\"latex gloves\",218,200)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount,minAmount) VALUES (1002,\"towel\",800,650)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount,minAmount) VALUES (1003,\"soap\",24,75)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount,minAmount) VALUES (1004,\"shampoo\",822,900)", con);  command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount,minAmount) VALUES (1005,\"bucket\",12,100)", con);  command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount,minAmount) VALUES (1006,\"nylon bags\",946,800)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount,minAmount) VALUES (1007,\"sheets\",725,700)", con); command.ExecuteNonQuery();
                /*command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount) VALUES (1008,\"tooth paste\",980)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount) VALUES (1009,\"towel\",663)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount) VALUES (1010,\"soap\",521)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount) VALUES (1011,\"tooth paste\",846)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount) VALUES (1012,\"latex gloves\",982)", con); command.ExecuteNonQuery();
                command = new System.Data.OleDb.OleDbCommand("INSERT INTO tbl_warehouse (itemID,description,amount) VALUES (1013,\"latex gloves\",547)", con); command.ExecuteNonQuery();
                */


                
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }
        public static void ExecuteNonQuery(string query)
        {
            try
            {
                con.Open();
                System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(query, con);
                command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
            }
        }

        /// <summary>
        /// To Execute queries which return scalar value
        /// </summary>
        /// <param name="query">the query string</param>
        public static object ExecuteScalar(string query)
        {
            try
            {
                con.Open();
                System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(query, con);
                return command.ExecuteScalar();
            }
            catch
            {
                throw;
            }
            finally
            {
                con.Close();
            }
        }

    }
}